WIP Activity Net of Retainers
The WIP Activity Net of Retainers report shows WIP activity totals for a specified period, allowing you to review WIP activity for a selected date range. The report also includes progress bills generated and applied to the WIP and the beginning and ending WIP balance.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is WIP Activity Net of Retainers. In Practice Advantage, there is no comparable report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Select to Include Transactions Using… |
List |
Determines the type of transaction date to use. The options are Transaction Date and Accounting Period Date. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
PTD |
Between |
First Day of Current Month, Today |
RTD |
Between |
First Day of Current Fiscal Year, Last Day of Current Fiscal Year |
Optional Filters | ||
---|---|---|
Available Fields | ||
Business Code |
Client Type |
PTD WIP Balance |
Client |
Financial Reporting Client Group |
PTD WIP Beg Balance |
Client – Principal |
Line of Business |
PTD WIP Write Up/Down |
Client Bill Manager |
Manager |
Return Group |
Client Business Unit |
Primary Partner |
RTD |
Client ID |
PTD |
RTD % Relieved WIP Adjust |
Client ID.Sub ID |
PTD % Relieved WIP Adjust |
RTD Billed Amounts |
Client Name |
PTD Billed Amounts |
RTD Production Amounts |
Client Office |
PTD Production Amounts |
RTD Progress Applied |
Client Primary Service Type |
PTD Progress Applied |
RTD Progress Billed |
Client Region |
PTD Progress Billed |
RTD WIP % |
Client Sub ID |
PTD WIP % |
RTD WIP Balance |
RTD WIP Beg Balance |
RTD Write Up/Down |
Tax Type |
RTD WIP End Balance |
Sort Name |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Name |
Line of Business |
Client |
Client Office |
Manager |
Client – Principal |
Client Primary Service Type |
Primary Partner |
Client Bill Manager |
Client Region |
Return Group |
Client Business Unit |
Client Sub ID |
Sort Name |
Client ID |
Client Type |
Tax Type |
Client ID.Sub ID |
Financial Reporting Client Group |
|
Sorting |
---|
Client |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client |
The client name in Client Name (Client ID.Sub-ID) format. |
WIP Beg Balance |
The total of all open WIP as of the date range selected. |
Production Amounts |
The total of all billable WIP posted for the date range selected, including expenses and surcharges. |
WIP Balance |
The total WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts. |
Billed Amounts |
The total of billed WIP amounts on posted invoices for the date ranged selected, including expenses and surcharges. |
Write Up/Down |
The total of all write up/down amounts for the date range selected. |
Progress Billed |
The total progress billed for the date range selected. |
Progress Applied |
The total progress applied for the date range selected. |
WIP End Balance |
The ending WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts – billed amounts – progress billed + progress applied. |
WIP % |
The WIP percentage for the date range selected. The calculation is (billed amounts – write up/down – progress billed + progress applied)/WIP balance. |
% Relieved WIP Adjust |
The percentage of the relieved WIP adjustment for the date range selected. The calculation is write up/down/(billed amounts – write up/down – progress billed + progress applied). |
WIP Activity Net of Retainers Sample Report